package social_network.dao;

import java.util.List;
import social_network.entities.UserMark;
import social_network.exceptions.NotExistsParameterException;
/**
 * Created with IntelliJ IDEA.
 * User: Alex
 * Date: 20.07.13
 * Time: 17:26
 */
public class UserMarkDaoImpl implements UserMarkDao {

    public final static String GET_MARK_BY_ID = "SELECT mark FROM network.user_mark\n"
            + "WHERE id = ?";

    public final static String GET_DESCRIPTION_BY_FILM_ID = "SELECT description FROM network.user_mark\n"
            + "WHERE film_id = ?";

    public final static String ADD_USER_MARK = "INSERT INTO network.user_mark "
            + "VALUES( null, ?, ?, ?, ? )";//TODO

    public final static String DELETE_MARK_BY_ID = "DELETE FROM network.user_mark"
            + "WHERE id = ?";

    public final static String UPDATE_DESCRIPTION_BY_ID = "UPDATE network.user_mark SET"
            + "description = ? WHERE film_id = ? AND user_id = ?";

    public static final String ATTRIBUTE_USER_ID = "user_id";
    public static final String ATTRIBUTE_FILM_ID = "film_id";
    public static final String ATTRIBUTE_mark = "mark";
    public static final String ATTRIBUTE_DESCRIPTION = "description";

    @Override
    public void addUserMarkAndDescription(UserMark userMark) {
        throw new UnsupportedOperationException("Not supported yet.");
    }

    @Override
    public List<UserMark> getDescriptionsByFilmId(int film_id) {
        throw new UnsupportedOperationException("Not supported yet.");
    }

    @Override
    public int getMarkByID(int user_id, int film_id) throws NotExistsParameterException {
        throw new UnsupportedOperationException("Not supported yet.");
    }

    @Override
    public void deleteMarkByID(int id) throws NotExistsParameterException {
        throw new UnsupportedOperationException("Not supported yet.");
    }

    @Override
    public void changeDescriptionByID(int user_id, int film_id) throws NotExistsParameterException {
        throw new UnsupportedOperationException("Not supported yet.");
    }

}